package me.zhengjie.repository;


import me.zhengjie.dto.sqlServer.InBoundStation;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

/**
* @website https://eladmin.vip
* @author ZhangYY
* @date 2024-01-19
**/
public interface InBoundStationRepository extends JpaRepository<InBoundStation, Integer>, JpaSpecificationExecutor<InBoundStation> {
    @Query("select i.reservoirAreaId from InBoundStation i where i.plcId=?1")
    int searchAreaByPlcId(int plcId);
}